home *** CD-ROM | disk | FTP | other *** search
Text File | 1996-09-18 | 9.4 KB | 1,201 lines |
- Pos.
- Aufwands/Ertrags-Art
- 1. Jahr
-
- 2. Jahr
-
- 3. Jahr
-
- Gesamt
-
-
-
-
-
-
-
-
-
-
-
- Nr.
-
- Betrag
- %
- Betrag
- %
- Betrag
- %
- Betrag
- %
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 1
- Umsatzerlös
- 1600
- 100
- 2000
- 100
- 2400
- 100
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- 100
-
-
-
-
-
-
-
-
-
-
- 2
- Skontoertrag
- 0
- [3,LINE()]/([3,4]*0.01)
- 0
- [5,LINE()]/([5,4]*0.01)
- 0
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 3
- Bestandsveränderungen
- 0
- [3,LINE()]/([3,4]*0.01)
- 0
- [5,LINE()]/([5,4]*0.01)
- 0
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 4
- Gesamtleistung (1-3)
- SUM([3,4]..[3,6])
- [3,LINE()]/([3,4]*0.01)
- SUM([5,4]..[5,6])
- [5,LINE()]/([5,4]*0.01)
- SUM([7,4]..[7,6])
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 5
- Wareneinsatz
- [3,4]*0.24
- [3,LINE()]/([3,4]*0.01)
- [5,4]*0.24
- [5,LINE()]/([5,4]*0.01)
- [7,4]*0.24
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 6
- Brutto-/Rohertrag
- [3,8]-[3,10]
- [3,LINE()]/([3,4]*0.01)
- [5,8]-[5,10]
- [5,LINE()]/([5,4]*0.01)
- [7,8]-[7,10]
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 7
- Skontoaufwand
- [3,4]*0.01
- [3,LINE()]/([3,4]*0.01)
- [5,4]*0.01
- [5,LINE()]/([5,4]*0.01)
- [7,4]*0.01
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 8
- Vertreterprovisionen
- [3,4]*0.227
- [3,LINE()]/([3,4]*0.01)
- [5,4]*0.227
- [5,LINE()]/([5,4]*0.01)
- [7,4]*0.227
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 9
- Verpackung u. Versand
- [3,4]*0.02
- [3,LINE()]/([3,4]*0.01)
- [5,4]*0.02
- [5,LINE()]/([5,4]*0.01)
- [7,4]*0.02
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 10
-
- 0
- [3,LINE()]/([3,4]*0.01)
- 0
- [5,LINE()]/([5,4]*0.01)
- 0
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 11
- Summe Variabler Kosten
- SUM([3,14]..[3,17])
- [3,LINE()]/([3,4]*0.01)
- SUM([5,14]..[5,17])
- [5,LINE()]/([5,4]*0.01)
- SUM([7,14]..[7,17])
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 12
- Deckungsbeitrag 1
- [3,12]-[3,19]
- [3,LINE()]/([3,4]*0.01)
- [5,12]-[5,19]
- [5,LINE()]/([5,4]*0.01)
- [7,12]-[7,19]
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 13
- Finanzierungkosten
- 22.8
- [3,LINE()]/([3,4]*0.01)
- 12
- [5,LINE()]/([5,4]*0.01)
- 0
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 14
- Deckungsbeitrag 2
- [3,21]-[3,23]
- [3,LINE()]/([3,4]*0.01)
- [5,21]-[5,23]
- [5,LINE()]/([5,4]*0.01)
- [7,21]-[7,23]
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 15
- Mieten
- 30
- [3,LINE()]/([3,4]*0.01)
- 30
- [5,LINE()]/([5,4]*0.01)
- 30
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 16
- Personalkosten
- 211.2
- [3,LINE()]/([3,4]*0.01)
- 211.2
- [5,LINE()]/([5,4]*0.01)
- 211.2
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 17
- Betriebssteuern
- 0
- [3,LINE()]/([3,4]*0.01)
- 0
- [5,LINE()]/([5,4]*0.01)
- 0
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 18
- Versicherungen
- 2.4
- [3,LINE()]/([3,4]*0.01)
- 2.4
- [5,LINE()]/([5,4]*0.01)
- 2.4
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 19
- Beiträge u. Gebühren
- 4.8
- [3,LINE()]/([3,4]*0.01)
- 4.8
- [5,LINE()]/([5,4]*0.01)
- 4.8
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 20
- KFZ-Aufwand
- 33.6
- [3,LINE()]/([3,4]*0.01)
- 33.6
- [5,LINE()]/([5,4]*0.01)
- 33.6
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 21
- Leasingaufwand
- 22.8
- [3,LINE()]/([3,4]*0.01)
- 22.8
- [5,LINE()]/([5,4]*0.01)
- 22.8
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 22
- Fahrt- u. Reiseaufwand
- 18
- [3,LINE()]/([3,4]*0.01)
- 18
- [5,LINE()]/([5,4]*0.01)
- 18
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 23
- Eingangsfrachten
- 0
- [3,LINE()]/([3,4]*0.01)
- 0
- [5,LINE()]/([5,4]*0.01)
- 0
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 24
- Reparaturen, Ersatzteile
- 0
- [3,LINE()]/([3,4]*0.01)
- 0
- [5,LINE()]/([5,4]*0.01)
- 0
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 25
- Bewirtung
- 3
- [3,LINE()]/([3,4]*0.01)
- 3
- [5,LINE()]/([5,4]*0.01)
- 3
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 26
- Energie (Gas,Strom,Wasser)
- 6
- [3,LINE()]/([3,4]*0.01)
- 6
- [5,LINE()]/([5,4]*0.01)
- 6
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 27
- Allg. Bürokosten (Porti,
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Tel.,Tx.,Zeitschr. etc.)
- 32.4
- [3,LINE()]/([3,4]*0.01)
- 32.4
- [5,LINE()]/([5,4]*0.01)
- 32.4
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 28
- Rechts-u. Beratungsaufw.
- 9.6
- [3,LINE()]/([3,4]*0.01)
- 9.6
- [5,LINE()]/([5,4]*0.01)
- 9.6
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 29
- Rechnungswesen
- 12
- [3,LINE()]/([3,4]*0.01)
- 12
- [5,LINE()]/([5,4]*0.01)
- 12
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 30
- Geldverkehrsaufwand
- 12
- [3,LINE()]/([3,4]*0.01)
- 12
- [5,LINE()]/([5,4]*0.01)
- 12
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 31
- Schadensfälle (Kund.ford.)
- 9
- [3,LINE()]/([3,4]*0.01)
- 9
- [5,LINE()]/([5,4]*0.01)
- 9
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- 32
- AfA
- 23.4
- [3,LINE()]/([3,4]*0.01)
- 23.4
- [5,LINE()]/([5,4]*0.01)
- 23.4
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 33
- Fixe Kosten Gesamt
- SUM([3,27]..[3,45])
- [3,LINE()]/([3,4]*0.01)
- SUM([5,27]..[5,45])
- [5,LINE()]/([5,4]*0.01)
- SUM([7,27]..[7,45])
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 34
- A.O. Aufwand
- 205
- [3,LINE()]/([3,4]*0.01)
- 200
- [5,LINE()]/([5,4]*0.01)
- 200
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- _____
- _________________________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
- __________
-
-
-
-
-
-
-
-
-
-
- 35
- Erfolg (Gewinn/Verlust)
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- vor Ertragssteuern
- [3,25]-[3,47]-[3,49]
- [3,LINE()]/([3,4]*0.01)
- [5,25]-[5,47]-[5,49]
- [5,LINE()]/([5,4]*0.01)
- [7,25]-[7,47]-[7,49]
- [7,LINE()]/([7,4]*0.01)
- [3,LINE()]+[5,LINE()]+[7,LINE()]
- [9,LINE()]/([9,4]*0.01)
-
-
-
-
-
-
-
-
-
-
- =====
- =========================
- ==========
- ==========
- ==========
- ==========
- ==========
- ==========
- ==========
- ==========
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- 12.01.1989/CALC
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- Dr.L.Marte
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-